package com.sl.au.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import com.sl.au.entity.EXDEviewPaymentTotal;

/**
 * 销售收入统计
 * @author yry
 *	2017-02-20
 */
@Transactional(readOnly = true)
public interface EXDEPayIncomeRepository extends JpaRepository<EXDEviewPaymentTotal, String> {
	//查询某一年的每个月的数据
	@Query("SELECT l FROM EXDEviewPaymentTotal as l where l.dPaymentDate like ''+?1+'%' order by l.dPaymentDate,l.superior")
	List<EXDEviewPaymentTotal> findAllTrance(String year);

}
